<%--
  Created by IntelliJ IDEA.
  User: 20554
  Date: 2024/12/9
  Time: 20:02
  To change this template use File | Settings | File Templates.
--%>
create table book
(
book_id         int          not null
primary key,
book_name       varchar(32)  null,
book_isbn       varchar(32)  null,
book_press      varchar(32)  null,
book_author     varchar(32)  null,
book_pagination int          null,
book_price      double(3, 2) null,
book_uploadtime varchar(32)  null,
book_status     varchar(1)   null,
book_borrower   varchar(32)  null,
book_borrowtime varchar(32)  null,
book_returntime varchar(32)  null
);

create table record
(
record_id         varchar(32) not null
primary key,
record_bookname   varchar(32) null,
record_bookisbn   varchar(32) null,
record_borrower   varchar(32) null,
record_borrowtime varchar(32) null,
record_remandtime varchar(32) null
);


create table user
(
user_id       int         not null comment '用户id'
primary key,
user_name     varchar(32) null comment '用户名称',
user_password varchar(32) null comment '用户密码',
user_email    varchar(32) null,
user_role     varchar(32) null,
user_status   varchar(1)  null
);